﻿CREATE TABLE [dbo].[UserGroups]
(
	[UserGroupID] INT NOT NULL PRIMARY KEY, 
    [UserGroupName] NCHAR(100) NOT NULL, 
    [RoleID] INT NOT NULL,
	CONSTRAINT FK_UserGroups_Roles FOREIGN KEY (RoleID) 
    REFERENCES Roles (RoleID) 
    ON DELETE CASCADE
    ON UPDATE CASCADE
)
